Fixed assets >  Processes >  Utilities >  Mass recoding  

Display all Hide all

This processing is used to mass replace some field values on the job objects: Fixed assets, Expenses, Lease contracts, Subsidies and Stock count notes.

The processing can be used:
- either to mass recodify a table,
- either during an intra-group sale processing in order to individually recodify an asset and its linked objects: the recoding can then concern several tables.

The recoding can concern:
- the fields checked by a miscellaneous table,
- the analytical dimensions
- and, in the case of intra-group sales: the Location and the Geographic site (with implicit recoding of the financial site).

SEEINFO This replacement is a simple recoding of the field value and unlike the modification carried out in transactional mode, this replacement does not generate any initiated action nor any event.

When the recoding is not designed for an Intra-group transfer, a processing option makes it possible for the user:

  • Either to add a new value in the table to be recodified along with recording its original value. A selection makes it possible to limit the objects processed and the population processed on these objects.
  • Either to physically replace the new value in the table to be recodified: the original value is then deleted on all the job objects and records.

Protection of the data integrity - Locking of the function

When carrying out the processing, it is prohibited to carry out a transactional modification of the population to be processed.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

This function is composed of:

  • A header used to specify the identification information as well as the processing options.
  • From the General setuptab used to view the code list of the table to be recodified and to enter the new codes.
  • From the Extended selection tab used to select the records to be processed on the master object specified on the General setuptab.

SEEINFO In the case of a recoding designed for an intra-group transfer, the processing setup of the recoding is limited to the reference entry of the transfer concerned, of the table to be processed and of the target codes of the table.The other information: processing options, object selection, company/site selection and extended selection, cannot be accessed.

Header

Presentation

The header contains the processing reference, its status, the code of the table to be recodified and if necessary, the reference of the intra-group transfer for which the processing is designed.

It also contains the options reserved to the processings that are not designed for the intra-group transfers, especially the status to assign to the former codes and the choice on whether to update or not the associations.

Close

 

Fields

The following fields are present on this tab :

Recoding

  • Reference (field REFCDF)

Recoding reference. It is a freely selected alphanumerical code.
Each reference deals with one single table.

  • Description (field REFDES)

Recoding description.

  • Process status (field PROSTA)

When creating the reference, only the status: To process or To process (Intra-group sale) can be selected.
At the end of the processing, the status is automatically changed into: Processed or Processed (Intra-group sale).

  • Table name (field TABNAM)

In creation mode, this field is used to enter the name of the table for which recoding some codes or of all the codes is required.
This can be:
- one of the miscellaneous tables of the Fixed assets or Expenses modules,
- one of the analytical dimensions table,
- theLocation table: LOC orGeographic sites: FCY, only if the recoding concerns an intra-group transfer.
Once the reference of the recoding created, the table can no longer be modified.

  • Table name (field TABNAMDES)

This non modifiable field displays the description of the table that is affected by the recoding.

  • Process date (field PRODAT)

This field, that cannot be modified, is automatically loaded with the date at which the recoding processing is carried out.

  • Intra-grp trans ref (field REFTRFCMP)

This field can be viewed only if the status of the processing is set to: To process (Intra-group transfer) or Processed (Intra-group transfer).

  • If it is a recoding: To process (Intra-group transfer), the reference of an existing transfer must be entered.
  • If it is a recoding: Processed (Intra-group transfer), this reference cannot be modified.
  • Operation description (field DESTRFCMP)

Title of the intra-group sale. Non-modifiable field.

This field is used only when the recoding concerns an analytical dimension type. The entry of the dimension type code is mandatory.

  • User (field PROUSR)

This non modifiable field displays the name of the user that has launched the processing.

Options

  • Prev code status (field STAOLDCOD)

This field can only be entered when the status of the processing is set toTo process.
It is used to specify if the former codes must be kept are deleted.
When the setup is designed to an intra-group transfer, the former codes must be kept, this field cannot be modified then.
In the case of an analytical dimensions table recoding:
-  It is also possible to assign the Inactive status to the former codes, in which case, it is necessary to enter a validity end date in the following field.
- Assign the Inactive or Deleted statuses to the former codes is only possible if the analytical dimensions table is not shared. If it is shared, the status automatically takes the Kept value.
  • Validity end date (field DATENDACT)

This field is displayed and can be entered only if the processing status is: To be processed, and if the recoding concerns the analytical dimensions table with the Previous status codes positioned at: Inactive
It is used to specify the date from which a record carrying the code to recodify, will not be modifiable if it keeps its original value.

  • Associations update (field FLGUPDASS)

This flag is activated to specify that an association will be recoded if one of its elements has been recoded (determining and/or determined value).
It is automatically activated and cannot be modified as soon as the Former codes status has for value: Deleted.
As soon as the processing status has for value: Processed, it can no longer be modified.
It automatically deactivated and cannot be modified when the recoding concerns an intra-group transfer.

  • Simulation (field FLGSIM)

This box is checked by default. It specifies that the processing is carried out in simulation mode. In this case, the controls and the process are carried out but no modification of the database is recorded.

  • Log : print of updates (field FLGTRCEDT)

This flag is used, when activated, to edit, in the log file, the details of the updates.
This flag cannot be entered:
- As soon as the processing status has for value: Processed.
- When the recoding concerns an intra-group transfer (the Log file option will be selected in the Intra-group transfer processing).

Close

 

Tab General parameter

Presentation

This tab is used to view the code list of the table to be recodified and to enter the new codes.

It is also used, for the recoding processings not destined to an intra-group transfer:

  • to select the objects on which the recoding will apply,
  • to select the companies and sites to which belong the records to be processed.

Close

 

Fields

The following fields are present on this tab :

Grid Recoding

  • Before(code) (field VALOLDCOD)

This column displays the list of table lines to recodify.
If the recoding concerns the FCY sites table:
- Only the geographical sites are suggested.
- Right-clicking on Site location Recod. on a line is used to display a window that authorizes the the site locations recoding.

  • Before (label) (field VALOLDDES)

Title of the table line. This information cannot be modified.

  • After (code) (field VALNEWCOD)

This column is used to enter the value of the new code, as long as the status of the processing has not been set to Processed or Processed (intra-group transfer).

  • When the recoding concerns a miscellaneous table or a non-shared analytical dimension table (CCE), the value of the new code will update, during the recoding processing, the target objects (Assets, Expenses ...) and will also create the codes of the processed table if this value does not exist.
     
  • When the recoding concerns the FCY sites table, the value of the new code will update the target objects (Assets, Expenses, ...) during the recoding processing on the LOC location table or on a shared analytical dimension table (CCE). However, it will not update the processed table, the codes must have been created in the table beforehand.
  • After (label) (field VALNEWDES)

This column cannot be modified if the status of the processing has been set to Processed or Processed (intra-group transfer).

  • When the recoding concerns a miscellaneous table and a non-shared analytical dimensions (CCE), this field is used to enter the title corresponding to the new code which will be inserted in the table. This field is loaded by default with the original title.
  • When the recoding concerns the FCY site table or a shared analytical dimension table (CCE), this field cannot be modified ; it displays the title corresponding to the code entered which must have been created in the table beforehand.
    SEEINFO When the recoding concerns a location table (LOC), this column is replaced by the one entitled After (Location).

Object selection

  • Master object (field OBCLDR)

The master object is the object on which the recoding is mainly carried out. This setup is applied when the status of the former codes has for value: Stored or Inactive.

  • When the status of the former codes is set on: Deleted, this field is empty and cannot be modified: all the objects must be processed and none of them can be a master object.
  • When the recoding is designed to an intra-group sale, the master object must be the Fixed asset.

SEEINFO The Physical count lists and Physical assetsobjects cannot be master objects.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.
  • Assets (field OBCPCDFAS)

This checkbox is used to specify that the recoding of the Fixed assets object is required.
When the master object is the Fixed asset, this box must be activated.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.
  • Expenses (field OBCPCDLOF)

This checkbox is used to specify that the recoding of the Expenses object is required.
When the master object is the Expense, this box must be activated.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.

  • Funding contracts (field OBCPCDLEA)

This checkbox is used to specify that the recoding of the Financial contracts object is required.
When the master object is the Lease contract, this box must be activated.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.

  • Subsidies (field OBCPCDGRT)

This checkbox is used to specify that the recoding of the Subsidies object is required.
When the master object is the Subsidy, this box must be activated.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.

  • Physical assets (field OBCPCDPHY)

This checkbox is used to specify that the recoding of the Physical assets object is required.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodingsfunction.

Grid Company selection

  • field FLGCPY

The activation of this box is used to select the company on which the processing must be carried out.
After selecting a company, all the financial sites that are assigned to it are selected by default.
A click right option is used to select/deselect all the companies or financial sites attached to the companies.

  • When the recoding is intended to an intra-group transfer, the selection of the companies/sites is forbidden as it is carried out at the level of the transfer setup.
  • When the statuses of the former codes are the following: Deleted, all the companies are systematically selected and cannot be deactivated.
  • When the statuses of the former codes are the following: Kept or Inactive and when the status is: To be processed, the selection of at least one company is mandatory.

The Identification Code for the company.

Grid Site selection

  • field FLGFCY

This checkbox is activated for the site to be taken into account in the processing. After selecting a company, all the financial sites that are linked to it are selected by default.
A click right option is used to select/deselect all the companies or financial sites attached to the companies.

  • When the recoding is intended to an intra-group transfer, the selection of the companies/sites is forbidden as it is carried out at the level of the transfer setup.
  • When the statuses of the former codes are the following: Deleted, all the companies are systematically selected and cannot be deactivated.
  • When the statuses of the former codes are the following: Kept or Inactive and when the status is: To be processed, the selection of at least one company is mandatory.

Identification Code for the company which the site is linked to.

This field cannot be modified and displays the code of the site on which the process is carried out.

Close

 

Selection terms of the record, depending on the choice of master object

General principles:

  • When the recoding is designed for an intra-group transfer, the master object must be the Fixed asset and the other objects cannot be entered.
  • When the statuses of the former codes have the following status: Deleted, no other master object can be selected: all the objects must be processed and none of them can be a master object.
  • When the former codes have as status, the value: Inactive or Saved, the following records are excluded from the processing:

- the assets that have been issued during the previous financial years,
- the expenses attached to the assets (when the master object is the Expense, even if the object other Assets is activated),
- the financial leasing contracts that have the status Terminated, Complete or Buyback,
- the subsidies with the status: Deleted,
- the stock count notes with the status: 6 - Asset in phase, 7 - Statement rejected, or those that belong to a close stock count operation.

Master script: Asset

Other object

Expenses

Financial leasing contracts

Subsidies

Stock count statements

Link with Company + Site + Asset reference

Link with Company + Site + Contract reference

Link with Company + Site + Investment project reference

Link with Bar codes or Bar code only

For 1 asset:
- - > x potential expenses

For 1 asset:
- - > Only 1 potential contract

For 1 asset:
- - > x potential subsidies (subsidies having the same investment project as the asset)

For 1 asset:
- - > x potential stock count statements

Master script: Expense

Other object

Assets

Financial leasing contracts

Subsidies

Stock count statements

Impossible because the expenses selected are only the expenses not linked with the assets


Impossible because no asset selected


Impossible because no asset selected


Impossible because no asset selected

Master script: Contract

Other object

Assets

Expenses

Subsidies

Stock count statements

Link with Company + Site + Contract reference


Reading of the x assets linked to the contract, then for each of them:
- - > x potential expenses

Reading of the x assets linked to the contract, then for each of them:
- - > x potential subsidies (subsidies having the same investment project as the asset)


Reading of the x assets linked to the contract, then for each of them:
- - > x potential stock count statements

For 1 contract:
- - > x potential assets

Master script: Subsidy

Other object

Assets

Expenses

Contracts

Stock count statements

Link with Company + Site + Investment project reference

Reading of the x assets linked to the subsidy (i.e. of the x assets having the same investment project as the subsidy), then for each of them:
- - > x potential expenses

Reading of the x assets linked to the subsidy (i.e. of the x assets having the same investment project as the subsidy), then for each of them:
- - > Only 1 potential contract

Reading of the x assets linked to the subsidy (i.e. of the x assets having the same investment project as the subsidy), then for each of them: - - > x potential stock count statements

For 1 asset:
- - > x potential subsidies

Master script: Stock count list and Physical elements: non-authorized

  • Example: Master script: Subsidy - Other object: Expenses

    Processing :

    For the subsidy processed:

    --> Research of the assets having benefited from this subsidy

    For each asset processed:

    --> Research of the assigned expenses
Special features on the recording of the analytical dimensions

  • The recoding will not systematically generate new codes in the analytical dimensions table contrary to the miscellaneous tables. The user may then manually create new analytical dimensions then the recoding will only modify the value in the records of the processed objects.
     
  • When the recoding is for a intra-group sale, only the following dimensions are displayed in the recoding table:
    - dimensions linked to the source company,
    - dimensions that are not linked to a company or a group of companies.

Special features on the recoding of the sites and localizations

The recoding will not systematically generate new codes in the site table (FCY) and in the location table (LOC) contrary to the miscellaneous tables.
The user may then manually create the new sites and/or locations, then the recoding will only modify the value in the records of the processed objects.
The recoding of the geographical sites and/or of the locations is used to implicitly recodify the financial site because, to a geographical site and to a (target) company corresponds only one financial site.

Action icon

Recoding site locations

This is an option available by right-clicking in the Recoding table, only when the recoding applies to geographical sites (case of an intra-group sale). 
This option is used to display a window authorizing the recoding of the site locations.

Reload grid

This is an option available by right-clicking in the Recoding table, only when the recoding applies to geographical sites (case of an intra-group sale). 
It is used to reload all the sites linked to the source company.

Tick all the Companies/Sites

This option, available on the Company selection and Site selection tables, is used to mass select all the companies and financial sites attached to the companies.
When the recoding is designed to an intra-group transfer, this option is not available, the selection is carried out at the level of the transfer setup.
When the statuses of the former codes are the following: Deleted, all the companies and assigned sites are systematically selected and cannot be unticked.

Untick all Companies/Sites

This option, available on the Company selection and Site selection tables, is used to mass deselect all the companies and financial sites attached to the companies.
When the statuses of the former codes are the following: Deleted, all the companies and assigned sites are systematically selected and cannot be unticked.

 

Close

 

Tab Extended selection

Presentation

This tab is used to carry out a selection of the records to be processed, concerning the master object specified at the level of the General setup tab.

SEEWARNING The extended selection is not accessible in the following cases:

  • The recoding is designed for an intra-group transfer, the selection of the assets is then carried out from the setup of the transfer Operation definition.
     
  • When the statuses of the former codes are the following: Deleted, at the level of the setup of the recoding processing. All the records belonging to all the entities must, indeed, be taken into account in the processing.

Close

 

Fields

The following fields are present on this tab :

Block number 1

  • Object (field OBJNAM)

 
  • Description (field OBJDES)

 

Block number 2

  • field INTTBL

 
  • field INTFLD

 
  • field INTOPE

 
  • field INTVAL

 

Indicate a table amongst the principal object table and the linked tables.
  • field FLD1

Indicate a field from the table.
  • field OPE1

Indicate the comparison operation:

  • The "indifferent" operator is used to obtain all records of an object.
  • The '* ?' operator is used to define wildcards.
  • field VAL1

Indicate the comparison value (without quotation marks for the alphanumeric fields).
  • field ANDOR2

Indicate the link between criteria lines.

Example :

If Expr1 and Expr2 or Expr3 (Expr = expression) are entered we would have :

(Expr1 & (Expr2 | (Expr3)))

 
  • field FLD2

 
  • field OPE2

 
  • field VAL2

 
  • field ANDOR3

 

 
  • field FLD3

 
  • field OPE3

 
  • field VAL3

 
  • field ANDOR4

 

 
  • field FLD4

 
  • field OPE4

 
  • field VAL4

 
  • field ANDOR5

 

 
  • field FLD5

 
  • field OPE5

 
  • field VAL5

 

Block number 3

  • field REQUETE

 

Close

 

Specific Buttons

This button is used to start the recoding processing.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation